Date & Time Formatting Guide
 
Specifier Displays
%b Line break
%tab Tab
c Date using the format given by the ShortDateFormat global variable, followed by the time using the format given by the LongTimeFormat global variable. The time is not displayed if the date-time value indicates midnight precisely.
d Day as a number without a leading zero (1-31).
dd Day as a number with a leading zero (01-31).
ddd Day as an abbreviation (Sun-Sat) using the strings given by the ShortDayNames global variable.
dddd Day as a full name (Sunday-Saturday) using the strings given by the LongDayNames global variable.
ddddd Date using the format given by the ShortDateFormat global variable.
dddddd Date using the format given by the LongDateFormat global variable.
m Month as a number without a leading zero (1-12). If the m specifier immediately follows an h or hh specifier, the minute rather than the month is displayed.
mm Month as a number with a leading zero (01-12). If the mm specifier immediately follows an h or hh specifier, the minute rather than the month is displayed.
mmm Month as an abbreviation (Jan-Dec) using the strings given by the ShortMonthNames global variable.
mmmm Month as a full name (January-December) using the strings given by the LongMonthNames global variable.
yy Year as a two-digit number (00-99).
yyyy Year as a four-digit number (0000-9999).
h Hour without a leading zero (0-23).
hh Hour with a leading zero (00-23).
n Minute without a leading zero (0-59).
nn Minute with a leading zero (00-59).
s Second without a leading zero (0-59).
ss Second with a leading zero (00-59).
z Millisecond without a leading zero (0-999).
zzz Millisecond with a leading zero (000-999).
t Time using the format given by the ShortTimeFormat global variable.
tt Time using the format given by the LongTimeFormat global variable.
am/pm Uses the 12-hour clock for the preceding h or hh specifier, and displays 'am' for any hour before noon, and 'pm' for any hour after noon. The am/pm specifier can use lower, upper, or mixed case, and the result is displayed accordingly.
a/p Uses the 12-hour clock for the preceding h or hh specifier, and displays 'a' for any hour before noon, and 'p' for any hour after noon. The a/p specifier can use lower, upper, or mixed case, and the result is displayed accordingly.
ampm Uses the 12-hour clock for the preceding h or hh specifier, and contents of the TimeAMString global variable for any hour before noon, and the contents of the TimePMString global variable for any hour after noon.
/ Date separator character given by the DateSeparator global variable.
: Time separator character given by the TimeSeparator global variable.
'xx'/"xx" Characters enclosed in single or double quotes are displayed as-is, and do not affect formatting.
%h Gives hours for smoother analog clock (Min: 0, Max: 12)
%m Gives minutes for smoother analog clock (Min: 0, Max: 60)
%s Gives seconds for smoother analog clock (Min: 0, Max: 60)
%hh Gives hours for smoother 24-hour analog clock (Min: 0, Max: 24)
%w Week number (1-52)
%hr Gives hours in 12-hour time (1 - 12)
%hrr Gives hours in 12-hour time with a leading zero (01 - 12)